// ExcelFile.h: interface for the CExcelFile class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_EXCELFILE_H__BFB4D576_182D_4834_85B6_B5A3D9F90DED__INCLUDED_)
#define AFX_EXCELFILE_H__BFB4D576_182D_4834_85B6_B5A3D9F90DED__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CMyODBC;
class AFX_EXT_CLASS CExcelFile  
{
public:
	
	CExcelFile(CString strFilePath);
	virtual ~CExcelFile();

	BOOL QueryRecord(CString strSheetName, CStringArray &strArrayColumnName);
	BOOL QueryRecord(CString strSheetName);
	BOOL GetNextRecord(CStringArray &strArrayOneRow, int &nColCount);
	void CloseQuery(void);

	BOOL AddRecord(CString strSheetName, const CStringArray &strArrayOneRow, const CStringArray &strArrayColName, int nColCount);
	BOOL DeleteAllRecord(CString strSheetName);

private:
	CMyODBC *m_pStream;
};

#endif // !defined(AFX_EXCELFILE_H__BFB4D576_182D_4834_85B6_B5A3D9F90DED__INCLUDED_)
